package keeto.com.vn.bms.database;

public class BMSDBString {
	
	public static final String USER_ACCOUNT_TABLE = "BMSAccount";
	public static final String USER_NOTIFY_TABLE = "BMSNotify";

	public static final String[] TABLENAME ={USER_ACCOUNT_TABLE,USER_NOTIFY_TABLE};
	public static final String[] CREATE_TABLE ={
		"CREATE TABLE " + USER_ACCOUNT_TABLE  +"(STT INTEGER PRIMARY KEY  AUTOINCREMENT," 
					+ "UserName TEXT NOT NULL DEFAULT '',"
					+ "FullName TEXT NOT NULL DEFAULT '',"
					+ "UserID TEXT NOT NULL DEFAULT '',"
					+ "UserEmail TEXT NOT NULL DEFAULT '',"
					+ "UserPhone TEXT NOT NULL DEFAULT '',"
					+ "UserPermission TEXT NOT NULL DEFAULT '');",
		"CREATE TABLE " + USER_NOTIFY_TABLE  +"(STT INTEGER PRIMARY KEY  AUTOINCREMENT," 
					+ "NotifyId TEXT NOT NULL DEFAULT '',"
					+ "NotifyTitle TEXT NOT NULL DEFAULT '',"
					+ "NotifyContent TEXT NOT NULL DEFAULT '',"
					+ "UserID TEXT NOT NULL DEFAULT '',"
					+ "UserFullname TEXT NOT NULL DEFAULT '',"
					+ "NotifyTime TEXT NOT NULL DEFAULT '',"
					+ "ObjId TEXT NOT NULL DEFAULT '',"
					+ "IsChecked INTEGER NOT NULL DEFAULT 0,"
					+ "IsReaded INTEGER NOT NULL DEFAULT 0);"			
	
	};
	
	
}
